dotConnect for SQLite Documentation
Devart.Data.SQLite Namespace / SQLiteScalarFunction<T1,T2,T3,T4,T5,T6,T7,TResult> Class
Type of the first user-defined function parameter.
Type of the second user-defined function parameter.
Type of the third user-defined function parameter.
Type of the fourth user-defined function parameter.
Type of the fifth user-defined function parameter.
Type of the sixth user-defined function parameter.
Type of the seventh user-defined function parameter.
Type of the user-defined function result.
Members

SQLiteScalarFunction<T1,T2,T3,T4,T5,T6,T7,TResult> Class
Base class for user-defined scalar functions with four parameters.
Syntax
'Declaration
 
Public MustInherit Class SQLiteScalarFunction
    (Of T1,T2,T3,T4,T5,T6,T7,TResult) 
   Inherits SQLiteScalarFunction
   Implements System.IDisposable 
 
Type Parameters
T1
Type of the first user-defined function parameter.
T2
Type of the second user-defined function parameter.
T3
Type of the third user-defined function parameter.
T4
Type of the fourth user-defined function parameter.
T5
Type of the fifth user-defined function parameter.
T6
Type of the sixth user-defined function parameter.
T7
Type of the seventh user-defined function parameter.
TResult
Type of the user-defined function result.
Remarks

Use this generic class to derive classes for user-defined scalar functions with four parameters from it. This generic class was introduced to ease the user-defined function creating. It allows to specify parameter count, type, and function result type. As an alternative, you may use SQLiteScalarFunction to create user-defined aggregate functions with any number of parameters.

The scalar function is a simple function, that returns a scalar value and is executed once when called.

To register the user-defined scalar funtion, create the class, derived from SQLiteScalarFunction and pass its name and number of arguments to the base class constructor.

You should also override the Execute(T1,T2,T3,T4,SQLiteConnection) method, which should implement the function actions.

Inheritance Hierarchy

System.Object
   Devart.Data.SQLite.SQLiteFunction
      Devart.Data.SQLite.SQLiteScalarFunction
         Devart.Data.SQLite.SQLiteScalarFunction<T1,T2,T3,T4,T5,T6,T7,TResult>

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also